SUPPORT / SAMPLES & SAS NOTES
Problem Note 61608: The "...No more data to read..." error occurs when you run the RANK procedure with SAS/ACCESS® Interface to Impala
 |  |  |  |  |
When you use PROC RANK with IMPALA tables, you can receive an error similar to the following:
proc rank data=x.test1 out=work.sortme;
var age height weight;
ranks rankage rankheig rankweig;
run;
ERROR: CLI error trying to establish connection:
[unixODBC][Cloudera][ImpalaODBC] (100) Error from the Impala Thrift API: No more
data to read.
ERROR: Connection to the IMPALA DBMS does not exist.
var age height weight;
ranks rankage rankheig rankweig;
run;
ERROR: CLI error trying to establish connection:
[unixODBC][Cloudera][ImpalaODBC] (100) Error from the Impala Thrift API: No more
data to read.
ERROR: Connection to the IMPALA DBMS does not exist.
You encounter this issue when you run code similar to the following:
libname x sasioimp server=your_server impala_principal=yourkerberoscredentials@company.com ;
Other procedures and DATA steps run correctly with this same LIBNAME statement. The problem occurs because the IMPALA_PRINCIPAL is not passed to the procedure correctly.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Impala | Microsoft® Windows® for x64 | 9.43 | 9.4 TS1M4 | ||
| 64-bit Enabled AIX | 9.43 | 9.4 TS1M4 | ||||
| Linux for x64 | 9.43 | 9.4 TS1M4 | ||||